Stored Procedures [dbo].[BAEEventGetRegistrants]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventGetRegistrants
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@userIDvarchar(30)30
@EventCodevarchar(10)10
SQL Script
create procedure [dbo].[BAEEventGetRegistrants] @userID VARCHAR(30),
     @EventCode VARCHAR(10) as
SELECT *
FROM EventRegistrant
WHERE RegistrantID=@userID AND EventCode=@EventCode

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved